INF3707 Database Design And Implementation

Latest exam pack questions and answers and summarized notes for exam preparation.

JUNE / JULY 2021 INF3707 DATABASE DESIGN AND IMPLEMENTATION Date: 05 July 2021 Duration: 2 hours Total marks: 100 Examiners: First: Dr B. Chipangura Second: Dr L. Motsi External: Dr P. Nkomo This is a closed book examination. Instructions to students 1. Unisa examination policies apply. 2. Answer all questions. 3. Study the tables and data in Annexure A. 4. The marks for each question are given in brackets next to the question. 5. Please answer the questions in or...

INF3707 - Database Design And Implementation EXAM PACK 2022. Question 1 10 marks 1.1 Which Oracle Database management system is prescribed for this module? (2 marks) 1.2 How do you login as the system administrator on the Oracle SQL*plus interface? Provide the code. (2 marks) 1.3 After you have successfully installed Oracle database, how do you open the pluggable databases so that they can automatically open? (4 marks) 1.4 By default, Oracle pluggable databases remain closed and must be ...

INF3707-Database Design And Implementation EXAM PACK 2022 . Question 1 10 marks 1.1 Which Oracle Database management system is prescribed for this module? (2 marks) 1.2 How do you login as the system administrator on the Oracle SQL*plus interface? Provide the code. (2 marks) 1.3 After you have successfully installed Oracle database, how do you open the pluggable databases so that they can automatically open? (4 marks) 1.4 By default, Oracle pluggable databases remain closed and must be ope...

INF3707-Database Design And Implementation EXAM PACK 2022. Question 1 10 marks 1.1 Which Oracle Database management system is prescribed for this module? (2 marks) 1.2 How do you login as the system administrator on the Oracle SQL*plus interface? Provide the code. (2 marks) 1.3 After you have successfully installed Oracle database, how do you open the pluggable databases so that they can automatically open? (4 marks) 1.4 By default, Oracle pluggable databases remain closed and must be open...

QUESTIONS

INF3707 Exam Pack 2023 Latest exam pack questions and answers and summarized notes for exam preparation. 100% TRUSTED workings, explanations and solutions. For assistance call or whatsapp us on +25477 954 0132 .

INF3707 Past Exams.100% CORRECT questions, answers, workings and explanations. Whatsapp +25479 093 7672 for assistance. May 2019 Section A Question 1 1. [40 Marks] 1.1. Which of the following is true of the SQL query given below? (Choose the best answer) SELECT col1, col2 FROM tab1 WHERE col1 = ‘A’ ORDER BY col2 DESC, col1; a. It will display the row which has the col1 value as ‘A’ ordered by the col1 in descending order and then col2 in the descending order. b. The ORDER BY...

INF3707 Assignment 3 2023.100% CORRECT questions, answers, workings and explanations. Whatsapp +25479 093 7672 for assistance. ........... Question 1: Chapter 6 (11 marks) 1.1 Create a sequence that generates integers starting with the value 5. Each value should be three less than the previous value generated. The lowest value should be 0, and the sequence should not be allowed to cycle. Name the sequence MY_FIRST_SEQ. (5 marks) 1.2 Issue a SELECT statement that displays NEXTVAL for MY_FIRST_S...

the document has the latest questions and elaborate answers